<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1" />
<meta name="generator" content="pdoc 0.10.0" />
<title>py3dtilers.CityTiler.citym_building API documentation</title>
<meta name="description" content="Notes on the 3DCityDB database structure …" />
<link rel="preload stylesheet" as="style" href="https://cdnjs.cloudflare.com/ajax/libs/10up-sanitize.css/11.0.1/sanitize.min.css" integrity="sha256-PK9q560IAAa6WVRRh76LtCaI8pjTJ2z11v0miyNNjrs=" crossorigin>
<link rel="preload stylesheet" as="style" href="https://cdnjs.cloudflare.com/ajax/libs/10up-sanitize.css/11.0.1/typography.min.css" integrity="sha256-7l/o7C8jubJiy74VsKTidCy1yBkRtiUGbVkYBylBqUg=" crossorigin>
<link rel="stylesheet preload" as="style" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/10.1.1/styles/github.min.css" crossorigin>
<style>:root{--highlight-color:#fe9}.flex{display:flex !important}body{line-height:1.5em}#content{padding:20px}#sidebar{padding:30px;overflow:hidden}#sidebar > *:last-child{margin-bottom:2cm}.http-server-breadcrumbs{font-size:130%;margin:0 0 15px 0}#footer{font-size:.75em;padding:5px 30px;border-top:1px solid #ddd;text-align:right}#footer p{margin:0 0 0 1em;display:inline-block}#footer p:last-child{margin-right:30px}h1,h2,h3,h4,h5{font-weight:300}h1{font-size:2.5em;line-height:1.1em}h2{font-size:1.75em;margin:1em 0 .50em 0}h3{font-size:1.4em;margin:25px 0 10px 0}h4{margin:0;font-size:105%}h1:target,h2:target,h3:target,h4:target,h5:target,h6:target{background:var(--highlight-color);padding:.2em 0}a{color:#058;text-decoration:none;transition:color .3s ease-in-out}a:hover{color:#e82}.title code{font-weight:bold}h2[id^="header-"]{margin-top:2em}.ident{color:#900}pre code{background:#f8f8f8;font-size:.8em;line-height:1.4em}code{background:#f2f2f1;padding:1px 4px;overflow-wrap:break-word}h1 code{background:transparent}pre{background:#f8f8f8;border:0;border-top:1px solid #ccc;border-bottom:1px solid #ccc;margin:1em 0;padding:1ex}#http-server-module-list{display:flex;flex-flow:column}#http-server-module-list div{display:flex}#http-server-module-list dt{min-width:10%}#http-server-module-list p{margin-top:0}.toc ul,#index{list-style-type:none;margin:0;padding:0}#index code{background:transparent}#index h3{border-bottom:1px solid #ddd}#index ul{padding:0}#index h4{margin-top:.6em;font-weight:bold}@media (min-width:200ex){#index .two-column{column-count:2}}@media (min-width:300ex){#index .two-column{column-count:3}}dl{margin-bottom:2em}dl dl:last-child{margin-bottom:4em}dd{margin:0 0 1em 3em}#header-classes + dl > dd{margin-bottom:3em}dd dd{margin-left:2em}dd p{margin:10px 0}.name{background:#eee;font-weight:bold;font-size:.85em;padding:5px 10px;display:inline-block;min-width:40%}.name:hover{background:#e0e0e0}dt:target .name{background:var(--highlight-color)}.name > span:first-child{white-space:nowrap}.name.class > span:nth-child(2){margin-left:.4em}.inherited{color:#999;border-left:5px solid #eee;padding-left:1em}.inheritance em{font-style:normal;font-weight:bold}.desc h2{font-weight:400;font-size:1.25em}.desc h3{font-size:1em}.desc dt code{background:inherit}.source summary,.git-link-div{color:#666;text-align:right;font-weight:400;font-size:.8em;text-transform:uppercase}.source summary > *{white-space:nowrap;cursor:pointer}.git-link{color:inherit;margin-left:1em}.source pre{max-height:500px;overflow:auto;margin:0}.source pre code{font-size:12px;overflow:visible}.hlist{list-style:none}.hlist li{display:inline}.hlist li:after{content:',\2002'}.hlist li:last-child:after{content:none}.hlist .hlist{display:inline;padding-left:1em}img{max-width:100%}td{padding:0 .5em}.admonition{padding:.1em .5em;margin-bottom:1em}.admonition-title{font-weight:bold}.admonition.note,.admonition.info,.admonition.important{background:#aef}.admonition.todo,.admonition.versionadded,.admonition.tip,.admonition.hint{background:#dfd}.admonition.warning,.admonition.versionchanged,.admonition.deprecated{background:#fd4}.admonition.error,.admonition.danger,.admonition.caution{background:lightpink}</style>
<style media="screen and (min-width: 700px)">@media screen and (min-width:700px){#sidebar{width:30%;height:100vh;overflow:auto;position:sticky;top:0}#content{width:70%;max-width:100ch;padding:3em 4em;border-left:1px solid #ddd}pre code{font-size:1em}.item .name{font-size:1em}main{display:flex;flex-direction:row-reverse;justify-content:flex-end}.toc ul ul,#index ul{padding-left:1.5em}.toc > ul > li{margin-top:.5em}}</style>
<style media="print">@media print{#sidebar h1{page-break-before:always}.source{display:none}}@media print{*{background:transparent !important;color:#000 !important;box-shadow:none !important;text-shadow:none !important}a[href]:after{content:" (" attr(href) ")";font-size:90%}a[href][title]:after{content:none}abbr[title]:after{content:" (" attr(title) ")"}.ir a:after,a[href^="javascript:"]:after,a[href^="#"]:after{content:""}pre,blockquote{border:1px solid #999;page-break-inside:avoid}thead{display:table-header-group}tr,img{page-break-inside:avoid}img{max-width:100% !important}@page{margin:0.5cm}p,h2,h3{orphans:3;widows:3}h1,h2,h3,h4,h5,h6{page-break-after:avoid}}</style>
<script defer src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/10.1.1/highlight.min.js" integrity="sha256-Uv3H6lx7dJmRfRvH8TH6kJD1TSK1aFcwgx+mdg3epi8=" crossorigin></script>
<script>window.addEventListener('DOMContentLoaded', () => hljs.initHighlighting())</script>
</head>
<body>
<main>
<article id="content">
<header>
<h1 class="title">Module <code>py3dtilers.CityTiler.citym_building</code></h1>
</header>
<section id="section-intro">
<p>Notes on the 3DCityDB database structure</p>
<p>The data is organised in the following way in the database:</p>
<ul>
<li>the building table contains the "abstract" building
subdivisions (building, building part)</li>
<li>
<p>the thematic_surface table contains all the surface objects (wall,
roof, floor), with links to the building object it belongs to
and the geometric data in the surface_geometry table</p>
</li>
<li>
<p>the cityobject table contains information about all the objects</p>
</li>
<li>the surface_geometry table contains the geometry of all objects</li>
</ul>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python"># -*- coding: utf-8 -*-
&#34;&#34;&#34;
Notes on the 3DCityDB database structure

The data is organised in the following way in the database:

- the building table contains the &#34;abstract&#34; building
subdivisions (building, building part)
- the thematic_surface table contains all the surface objects (wall,
roof, floor), with links to the building object it belongs to
and the geometric data in the surface_geometry table

- the cityobject table contains information about all the objects
- the surface_geometry table contains the geometry of all objects

&#34;&#34;&#34;
from py3dtiles import TemporalBatchTable, TemporalBoundingVolume
from py3dtiles import temporal_extract_bounding_dates
from .citym_cityobject import CityMCityObject, CityMCityObjects
from .database_accesses_batch_table_hierarchy import create_batch_table_hierarchy


class CityMBuilding(CityMCityObject):
    &#34;&#34;&#34;
    Implementation of the Building Model objects from the CityGML model.
    &#34;&#34;&#34;

    def __init__(self, database_id=None, gml_id=None):
        super().__init__(database_id, gml_id)
        self.objects_type = CityMBuildings


class CityMBuildings(CityMCityObjects):
    &#34;&#34;&#34;
    A decorated list of CityMBuilding type objects.
    &#34;&#34;&#34;

    object_type = CityMBuilding

    # with_bth value is set to False by default. the value of this variable
    # depends on the command line optional argument &#34;--With_BTH&#34; of CityTiler.
    with_bth = False

    def __init__(self, features=None):
        super().__init__(features)

    @classmethod
    def set_bth(cls):
        cls.with_bth = True

    @classmethod
    def is_bth_set(cls):
        return cls.with_bth

    @staticmethod
    def sql_query_objects(buildings, citygml_ids=list()):
        &#34;&#34;&#34;
        :param buildings: a list of CityMBuilding type object that should be sought
                        in the database. When this list is empty all the objects
                        encountered in the database are returned.
        :param citygml_ids: a list of cityGML IDs. If the list isn&#39;t empty, we keep
                        only the objects of the list

        :return: a string containing the right SQL query that should be executed.
        &#34;&#34;&#34;
        if not buildings:
            # No specific buildings were sought. We thus retrieve all the ones
            # we can find in the database:
            query = &#34;SELECT building.id, cityobject.gmlid &#34; + \
                    &#34;FROM citydb.building JOIN citydb.cityobject ON building.id=cityobject.id &#34; + \
                    &#34;WHERE building.id=building.building_root_id&#34;
            if len(citygml_ids) &gt; 0:
                citygml_ids_as_string = &#34;(&#39;&#34; + &#34;&#39;, &#39;&#34;.join(citygml_ids) + &#34;&#39;)&#34;
                query += &#34; AND cityobject.gmlid IN &#34; + citygml_ids_as_string
        else:
            building_gmlids = [n.get_gml_id() for n in buildings]
            building_gmlids_as_string = &#34;(&#39;&#34; + &#34;&#39;, &#39;&#34;.join(building_gmlids) + &#34;&#39;)&#34;
            query = &#34;SELECT building.id, cityobject.gmlid &#34; + \
                    &#34;FROM citydb.building JOIN citydb.cityobject ON building.id=cityobject.id &#34; + \
                    &#34;WHERE cityobject.gmlid IN &#34; + building_gmlids_as_string + &#34; &#34; + \
                    &#34;AND building.id=building.building_root_id&#34;

        return query

    @staticmethod
    def sql_query_geometries(buildings_ids_arg, split_surfaces=False):
        &#34;&#34;&#34;
        :param buildings_ids_arg: a formatted list of (city)gml identifier corresponding to
                            objects_type type objects whose geometries are sought.
        :param split_surfaces: a boolean specifying if the surfaces of each building will stay
                            splitted or be merged into one geometry

        :return: a string containing the right SQL query that should be executed.
        &#34;&#34;&#34;
        # Because the 3DCityDB&#39;s Building table regroups both the buildings mixed
        # with their building&#39;s sub-divisions (Building is an &#34;abstraction&#34;
        # from which inherits concrete building class as well building-subdivisions
        # a.k.a. parts) we must first collect all the buildings and their parts:

        if split_surfaces:
            query = \
                &#34;SELECT surface_geometry.id, ST_AsBinary(ST_Multi( &#34; + \
                &#34;surface_geometry.geometry)), &#34; + \
                &#34;objectclass.classname &#34; + \
                &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
                &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
                &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
                &#34;JOIN citydb.objectclass ON thematic_surface.objectclass_id = objectclass.id &#34; + \
                &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg
        else:
            query = \
                &#34;SELECT building.building_root_id, ST_AsBinary(ST_Multi(ST_Collect( &#34; + \
                &#34;surface_geometry.geometry))), &#34; + \
                &#34;objectclass.classname &#34; + \
                &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
                &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
                &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
                &#34;JOIN citydb.objectclass ON building.objectclass_id = objectclass.id &#34; + \
                &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg + &#34; &#34; + \
                &#34;GROUP BY building.building_root_id, objectclass.classname&#34;

        return query

    @staticmethod
    def sql_query_geometries_with_texture_coordinates(buildings_ids_arg):
        &#34;&#34;&#34;
        :param buildings_ids_arg: a formatted list of (city)gml identifier corresponding to
                            objects_type type objects whose geometries are sought.
        :return: a string containing the right SQL query that should be executed.
        &#34;&#34;&#34;
        # Because the 3DCityDB&#39;s Building table regroups both the buildings mixed
        # with their building&#39;s sub-divisions (Building is an &#34;abstraction&#34;
        # from which inherits concrete building class as well building-subdivisions
        # a.k.a. parts) we must first collect all the buildings and their parts:
        query = (&#34;SELECT surface_geometry.id, &#34;
                 &#34;ST_AsBinary(ST_Multi(surface_geometry.geometry)) as geom , &#34;
                 &#34;ST_AsBinary(ST_Multi(ST_Translate(ST_Scale(textureparam.texture_coordinates, 1, -1), 0, 1))) as uvs, &#34;
                 &#34;tex_image_uri AS uri FROM citydb.building JOIN &#34;
                 &#34;citydb.thematic_surface ON building.id=thematic_surface.building_id JOIN &#34;
                 &#34;citydb.surface_geometry ON surface_geometry.root_id=&#34;
                 &#34;thematic_surface.lod2_multi_surface_id JOIN citydb.textureparam ON &#34;
                 &#34;textureparam.surface_geometry_id=surface_geometry.id &#34;
                 &#34;JOIN citydb.surface_data ON textureparam.surface_data_id=surface_data.id &#34;
                 &#34;JOIN citydb.tex_image ON surface_data.tex_image_id=tex_image.id &#34;
                 &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg)
        return query

    @staticmethod
    def sql_query_centroid(id):
        &#34;&#34;&#34;
        param id: the ID of the cityGML object
        return: the [x, y, z] coordinates of the centroid of the cityGML object
        &#34;&#34;&#34;

        query = \
            &#34;SELECT &#34; + \
            &#34;ST_X(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
            &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))), &#34; + \
            &#34;ST_Y(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
            &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))), &#34; + \
            &#34;ST_Z(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
            &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))) &#34; + \
            &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
            &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
            &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
            &#34;WHERE building.building_root_id = &#34; + str(id) + \
            &#34; GROUP BY building.building_root_id&#34;

        return query

    @staticmethod
    def create_batch_table_extension(extension_name, ids=None, objects=None):
        if CityMBuildings.is_bth_set() and extension_name == &#34;batch_table_hierarchy&#34;:
            cityobjects_ids = &#34;(&#34;
            for i in range(0, len(ids) - 1):
                cityobjects_ids += str(ids[i]) + &#39;,&#39;
            cityobjects_ids += str(ids[-1]) + &#39;)&#39;
            return create_batch_table_hierarchy(CityMCityObjects.get_cursor(), cityobjects_ids)

        if extension_name == &#34;temporal&#34;:
            temporal_bt = TemporalBatchTable()

            for building in objects:
                temporal_bt.append_feature_id(building.get_temporal_id())
                temporal_bt.append_start_date(building.get_start_date())
                temporal_bt.append_end_date(building.get_end_date())
            return temporal_bt

        return None

    @staticmethod
    def create_bounding_volume_extension(extension_name, ids=None, objects=None):
        if extension_name == &#34;temporal&#34;:
            temporal_bv = TemporalBoundingVolume()
            bounding_dates = temporal_extract_bounding_dates(objects)
            temporal_bv.set_start_date(bounding_dates[&#39;start_date&#39;])
            temporal_bv.set_end_date(bounding_dates[&#39;end_date&#39;])
            return temporal_bv
        return None</code></pre>
</details>
</section>
<section>
</section>
<section>
</section>
<section>
</section>
<section>
<h2 class="section-title" id="header-classes">Classes</h2>
<dl>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuilding"><code class="flex name class">
<span>class <span class="ident">CityMBuilding</span></span>
<span>(</span><span>database_id=None, gml_id=None)</span>
</code></dt>
<dd>
<div class="desc"><p>Implementation of the Building Model objects from the CityGML model.</p>
<p>:param id: given identifier</p></div>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python">class CityMBuilding(CityMCityObject):
    &#34;&#34;&#34;
    Implementation of the Building Model objects from the CityGML model.
    &#34;&#34;&#34;

    def __init__(self, database_id=None, gml_id=None):
        super().__init__(database_id, gml_id)
        self.objects_type = CityMBuildings</code></pre>
</details>
<h3>Ancestors</h3>
<ul class="hlist">
<li><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObject">CityMCityObject</a></li>
<li><a title="py3dtilers.Common.feature.Feature" href="../Common/feature.html#py3dtilers.Common.feature.Feature">Feature</a></li>
</ul>
<h3>Subclasses</h3>
<ul class="hlist">
<li><a title="py3dtilers.CityTiler.temporal_building.TemporalBuilding" href="temporal_building.html#py3dtilers.CityTiler.temporal_building.TemporalBuilding">TemporalBuilding</a></li>
</ul>
<h3>Inherited members</h3>
<ul class="hlist">
<li><code><b><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObject">CityMCityObject</a></b></code>:
<ul class="hlist">
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_batchtable_data" href="../Common/feature.html#py3dtilers.Common.feature.Feature.get_batchtable_data">get_batchtable_data</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_bounding_volume_box" href="../Common/feature.html#py3dtilers.Common.feature.Feature.get_bounding_volume_box">get_bounding_volume_box</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_centroid" href="../Common/feature.html#py3dtilers.Common.feature.Feature.get_centroid">get_centroid</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_database_id" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_database_id">get_database_id</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_geom" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_geom">get_geom</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_geom_as_triangles" href="../Common/feature.html#py3dtilers.Common.feature.Feature.get_geom_as_triangles">get_geom_as_triangles</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_gml_id" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_gml_id">get_gml_id</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_id" href="../Common/feature.html#py3dtilers.Common.feature.Feature.get_id">get_id</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.get_texture" href="../Common/feature.html#py3dtilers.Common.feature.Feature.get_texture">get_texture</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.has_texture" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObject.has_texture">has_texture</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_batchtable_data" href="../Common/feature.html#py3dtilers.Common.feature.Feature.set_batchtable_data">set_batchtable_data</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_box" href="../Common/feature.html#py3dtilers.Common.feature.Feature.set_box">set_box</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_database_id" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_database_id">set_database_id</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_gml_id" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_gml_id">set_gml_id</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_id" href="../Common/feature.html#py3dtilers.Common.feature.Feature.set_id">set_id</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_texture" href="../Common/feature.html#py3dtilers.Common.feature.Feature.set_texture">set_texture</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObject.set_triangles" href="../Common/feature.html#py3dtilers.Common.feature.Feature.set_triangles">set_triangles</a></code></li>
</ul>
</li>
</ul>
</dd>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuildings"><code class="flex name class">
<span>class <span class="ident">CityMBuildings</span></span>
<span>(</span><span>features=None)</span>
</code></dt>
<dd>
<div class="desc"><p>A decorated list of CityMBuilding type objects.</p></div>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python">class CityMBuildings(CityMCityObjects):
    &#34;&#34;&#34;
    A decorated list of CityMBuilding type objects.
    &#34;&#34;&#34;

    object_type = CityMBuilding

    # with_bth value is set to False by default. the value of this variable
    # depends on the command line optional argument &#34;--With_BTH&#34; of CityTiler.
    with_bth = False

    def __init__(self, features=None):
        super().__init__(features)

    @classmethod
    def set_bth(cls):
        cls.with_bth = True

    @classmethod
    def is_bth_set(cls):
        return cls.with_bth

    @staticmethod
    def sql_query_objects(buildings, citygml_ids=list()):
        &#34;&#34;&#34;
        :param buildings: a list of CityMBuilding type object that should be sought
                        in the database. When this list is empty all the objects
                        encountered in the database are returned.
        :param citygml_ids: a list of cityGML IDs. If the list isn&#39;t empty, we keep
                        only the objects of the list

        :return: a string containing the right SQL query that should be executed.
        &#34;&#34;&#34;
        if not buildings:
            # No specific buildings were sought. We thus retrieve all the ones
            # we can find in the database:
            query = &#34;SELECT building.id, cityobject.gmlid &#34; + \
                    &#34;FROM citydb.building JOIN citydb.cityobject ON building.id=cityobject.id &#34; + \
                    &#34;WHERE building.id=building.building_root_id&#34;
            if len(citygml_ids) &gt; 0:
                citygml_ids_as_string = &#34;(&#39;&#34; + &#34;&#39;, &#39;&#34;.join(citygml_ids) + &#34;&#39;)&#34;
                query += &#34; AND cityobject.gmlid IN &#34; + citygml_ids_as_string
        else:
            building_gmlids = [n.get_gml_id() for n in buildings]
            building_gmlids_as_string = &#34;(&#39;&#34; + &#34;&#39;, &#39;&#34;.join(building_gmlids) + &#34;&#39;)&#34;
            query = &#34;SELECT building.id, cityobject.gmlid &#34; + \
                    &#34;FROM citydb.building JOIN citydb.cityobject ON building.id=cityobject.id &#34; + \
                    &#34;WHERE cityobject.gmlid IN &#34; + building_gmlids_as_string + &#34; &#34; + \
                    &#34;AND building.id=building.building_root_id&#34;

        return query

    @staticmethod
    def sql_query_geometries(buildings_ids_arg, split_surfaces=False):
        &#34;&#34;&#34;
        :param buildings_ids_arg: a formatted list of (city)gml identifier corresponding to
                            objects_type type objects whose geometries are sought.
        :param split_surfaces: a boolean specifying if the surfaces of each building will stay
                            splitted or be merged into one geometry

        :return: a string containing the right SQL query that should be executed.
        &#34;&#34;&#34;
        # Because the 3DCityDB&#39;s Building table regroups both the buildings mixed
        # with their building&#39;s sub-divisions (Building is an &#34;abstraction&#34;
        # from which inherits concrete building class as well building-subdivisions
        # a.k.a. parts) we must first collect all the buildings and their parts:

        if split_surfaces:
            query = \
                &#34;SELECT surface_geometry.id, ST_AsBinary(ST_Multi( &#34; + \
                &#34;surface_geometry.geometry)), &#34; + \
                &#34;objectclass.classname &#34; + \
                &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
                &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
                &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
                &#34;JOIN citydb.objectclass ON thematic_surface.objectclass_id = objectclass.id &#34; + \
                &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg
        else:
            query = \
                &#34;SELECT building.building_root_id, ST_AsBinary(ST_Multi(ST_Collect( &#34; + \
                &#34;surface_geometry.geometry))), &#34; + \
                &#34;objectclass.classname &#34; + \
                &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
                &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
                &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
                &#34;JOIN citydb.objectclass ON building.objectclass_id = objectclass.id &#34; + \
                &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg + &#34; &#34; + \
                &#34;GROUP BY building.building_root_id, objectclass.classname&#34;

        return query

    @staticmethod
    def sql_query_geometries_with_texture_coordinates(buildings_ids_arg):
        &#34;&#34;&#34;
        :param buildings_ids_arg: a formatted list of (city)gml identifier corresponding to
                            objects_type type objects whose geometries are sought.
        :return: a string containing the right SQL query that should be executed.
        &#34;&#34;&#34;
        # Because the 3DCityDB&#39;s Building table regroups both the buildings mixed
        # with their building&#39;s sub-divisions (Building is an &#34;abstraction&#34;
        # from which inherits concrete building class as well building-subdivisions
        # a.k.a. parts) we must first collect all the buildings and their parts:
        query = (&#34;SELECT surface_geometry.id, &#34;
                 &#34;ST_AsBinary(ST_Multi(surface_geometry.geometry)) as geom , &#34;
                 &#34;ST_AsBinary(ST_Multi(ST_Translate(ST_Scale(textureparam.texture_coordinates, 1, -1), 0, 1))) as uvs, &#34;
                 &#34;tex_image_uri AS uri FROM citydb.building JOIN &#34;
                 &#34;citydb.thematic_surface ON building.id=thematic_surface.building_id JOIN &#34;
                 &#34;citydb.surface_geometry ON surface_geometry.root_id=&#34;
                 &#34;thematic_surface.lod2_multi_surface_id JOIN citydb.textureparam ON &#34;
                 &#34;textureparam.surface_geometry_id=surface_geometry.id &#34;
                 &#34;JOIN citydb.surface_data ON textureparam.surface_data_id=surface_data.id &#34;
                 &#34;JOIN citydb.tex_image ON surface_data.tex_image_id=tex_image.id &#34;
                 &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg)
        return query

    @staticmethod
    def sql_query_centroid(id):
        &#34;&#34;&#34;
        param id: the ID of the cityGML object
        return: the [x, y, z] coordinates of the centroid of the cityGML object
        &#34;&#34;&#34;

        query = \
            &#34;SELECT &#34; + \
            &#34;ST_X(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
            &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))), &#34; + \
            &#34;ST_Y(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
            &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))), &#34; + \
            &#34;ST_Z(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
            &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))) &#34; + \
            &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
            &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
            &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
            &#34;WHERE building.building_root_id = &#34; + str(id) + \
            &#34; GROUP BY building.building_root_id&#34;

        return query

    @staticmethod
    def create_batch_table_extension(extension_name, ids=None, objects=None):
        if CityMBuildings.is_bth_set() and extension_name == &#34;batch_table_hierarchy&#34;:
            cityobjects_ids = &#34;(&#34;
            for i in range(0, len(ids) - 1):
                cityobjects_ids += str(ids[i]) + &#39;,&#39;
            cityobjects_ids += str(ids[-1]) + &#39;)&#39;
            return create_batch_table_hierarchy(CityMCityObjects.get_cursor(), cityobjects_ids)

        if extension_name == &#34;temporal&#34;:
            temporal_bt = TemporalBatchTable()

            for building in objects:
                temporal_bt.append_feature_id(building.get_temporal_id())
                temporal_bt.append_start_date(building.get_start_date())
                temporal_bt.append_end_date(building.get_end_date())
            return temporal_bt

        return None

    @staticmethod
    def create_bounding_volume_extension(extension_name, ids=None, objects=None):
        if extension_name == &#34;temporal&#34;:
            temporal_bv = TemporalBoundingVolume()
            bounding_dates = temporal_extract_bounding_dates(objects)
            temporal_bv.set_start_date(bounding_dates[&#39;start_date&#39;])
            temporal_bv.set_end_date(bounding_dates[&#39;end_date&#39;])
            return temporal_bv
        return None</code></pre>
</details>
<h3>Ancestors</h3>
<ul class="hlist">
<li><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects">CityMCityObjects</a></li>
<li><a title="py3dtilers.Common.feature.FeatureList" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList">FeatureList</a></li>
</ul>
<h3>Class variables</h3>
<dl>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuildings.with_bth"><code class="name">var <span class="ident">with_bth</span></code></dt>
<dd>
<div class="desc"></div>
</dd>
</dl>
<h3>Static methods</h3>
<dl>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuildings.is_bth_set"><code class="name flex">
<span>def <span class="ident">is_bth_set</span></span>(<span>)</span>
</code></dt>
<dd>
<div class="desc"></div>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python">@classmethod
def is_bth_set(cls):
    return cls.with_bth</code></pre>
</details>
</dd>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuildings.set_bth"><code class="name flex">
<span>def <span class="ident">set_bth</span></span>(<span>)</span>
</code></dt>
<dd>
<div class="desc"></div>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python">@classmethod
def set_bth(cls):
    cls.with_bth = True</code></pre>
</details>
</dd>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_centroid"><code class="name flex">
<span>def <span class="ident">sql_query_centroid</span></span>(<span>id)</span>
</code></dt>
<dd>
<div class="desc"><p>param id: the ID of the cityGML object
return: the [x, y, z] coordinates of the centroid of the cityGML object</p></div>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python">@staticmethod
def sql_query_centroid(id):
    &#34;&#34;&#34;
    param id: the ID of the cityGML object
    return: the [x, y, z] coordinates of the centroid of the cityGML object
    &#34;&#34;&#34;

    query = \
        &#34;SELECT &#34; + \
        &#34;ST_X(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
        &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))), &#34; + \
        &#34;ST_Y(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
        &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))), &#34; + \
        &#34;ST_Z(ST_3DClosestPoint(ST_Multi(ST_Collect(surface_geometry.geometry)) &#34; + \
        &#34;,ST_Centroid(ST_Multi(ST_Collect(surface_geometry.geometry))))) &#34; + \
        &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
        &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
        &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
        &#34;WHERE building.building_root_id = &#34; + str(id) + \
        &#34; GROUP BY building.building_root_id&#34;

    return query</code></pre>
</details>
</dd>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_geometries"><code class="name flex">
<span>def <span class="ident">sql_query_geometries</span></span>(<span>buildings_ids_arg, split_surfaces=False)</span>
</code></dt>
<dd>
<div class="desc"><p>:param buildings_ids_arg: a formatted list of (city)gml identifier corresponding to
objects_type type objects whose geometries are sought.
:param split_surfaces: a boolean specifying if the surfaces of each building will stay
splitted or be merged into one geometry</p>
<p>:return: a string containing the right SQL query that should be executed.</p></div>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python">@staticmethod
def sql_query_geometries(buildings_ids_arg, split_surfaces=False):
    &#34;&#34;&#34;
    :param buildings_ids_arg: a formatted list of (city)gml identifier corresponding to
                        objects_type type objects whose geometries are sought.
    :param split_surfaces: a boolean specifying if the surfaces of each building will stay
                        splitted or be merged into one geometry

    :return: a string containing the right SQL query that should be executed.
    &#34;&#34;&#34;
    # Because the 3DCityDB&#39;s Building table regroups both the buildings mixed
    # with their building&#39;s sub-divisions (Building is an &#34;abstraction&#34;
    # from which inherits concrete building class as well building-subdivisions
    # a.k.a. parts) we must first collect all the buildings and their parts:

    if split_surfaces:
        query = \
            &#34;SELECT surface_geometry.id, ST_AsBinary(ST_Multi( &#34; + \
            &#34;surface_geometry.geometry)), &#34; + \
            &#34;objectclass.classname &#34; + \
            &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
            &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
            &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
            &#34;JOIN citydb.objectclass ON thematic_surface.objectclass_id = objectclass.id &#34; + \
            &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg
    else:
        query = \
            &#34;SELECT building.building_root_id, ST_AsBinary(ST_Multi(ST_Collect( &#34; + \
            &#34;surface_geometry.geometry))), &#34; + \
            &#34;objectclass.classname &#34; + \
            &#34;FROM citydb.surface_geometry JOIN citydb.thematic_surface &#34; + \
            &#34;ON surface_geometry.root_id=thematic_surface.lod2_multi_surface_id &#34; + \
            &#34;JOIN citydb.building ON thematic_surface.building_id = building.id &#34; + \
            &#34;JOIN citydb.objectclass ON building.objectclass_id = objectclass.id &#34; + \
            &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg + &#34; &#34; + \
            &#34;GROUP BY building.building_root_id, objectclass.classname&#34;

    return query</code></pre>
</details>
</dd>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_geometries_with_texture_coordinates"><code class="name flex">
<span>def <span class="ident">sql_query_geometries_with_texture_coordinates</span></span>(<span>buildings_ids_arg)</span>
</code></dt>
<dd>
<div class="desc"><p>:param buildings_ids_arg: a formatted list of (city)gml identifier corresponding to
objects_type type objects whose geometries are sought.
:return: a string containing the right SQL query that should be executed.</p></div>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python">@staticmethod
def sql_query_geometries_with_texture_coordinates(buildings_ids_arg):
    &#34;&#34;&#34;
    :param buildings_ids_arg: a formatted list of (city)gml identifier corresponding to
                        objects_type type objects whose geometries are sought.
    :return: a string containing the right SQL query that should be executed.
    &#34;&#34;&#34;
    # Because the 3DCityDB&#39;s Building table regroups both the buildings mixed
    # with their building&#39;s sub-divisions (Building is an &#34;abstraction&#34;
    # from which inherits concrete building class as well building-subdivisions
    # a.k.a. parts) we must first collect all the buildings and their parts:
    query = (&#34;SELECT surface_geometry.id, &#34;
             &#34;ST_AsBinary(ST_Multi(surface_geometry.geometry)) as geom , &#34;
             &#34;ST_AsBinary(ST_Multi(ST_Translate(ST_Scale(textureparam.texture_coordinates, 1, -1), 0, 1))) as uvs, &#34;
             &#34;tex_image_uri AS uri FROM citydb.building JOIN &#34;
             &#34;citydb.thematic_surface ON building.id=thematic_surface.building_id JOIN &#34;
             &#34;citydb.surface_geometry ON surface_geometry.root_id=&#34;
             &#34;thematic_surface.lod2_multi_surface_id JOIN citydb.textureparam ON &#34;
             &#34;textureparam.surface_geometry_id=surface_geometry.id &#34;
             &#34;JOIN citydb.surface_data ON textureparam.surface_data_id=surface_data.id &#34;
             &#34;JOIN citydb.tex_image ON surface_data.tex_image_id=tex_image.id &#34;
             &#34;WHERE building.building_root_id IN &#34; + buildings_ids_arg)
    return query</code></pre>
</details>
</dd>
<dt id="py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_objects"><code class="name flex">
<span>def <span class="ident">sql_query_objects</span></span>(<span>buildings, citygml_ids=[])</span>
</code></dt>
<dd>
<div class="desc"><p>:param buildings: a list of CityMBuilding type object that should be sought
in the database. When this list is empty all the objects
encountered in the database are returned.
:param citygml_ids: a list of cityGML IDs. If the list isn't empty, we keep
only the objects of the list</p>
<p>:return: a string containing the right SQL query that should be executed.</p></div>
<details class="source">
<summary>
<span>Expand source code</span>
</summary>
<pre><code class="python">@staticmethod
def sql_query_objects(buildings, citygml_ids=list()):
    &#34;&#34;&#34;
    :param buildings: a list of CityMBuilding type object that should be sought
                    in the database. When this list is empty all the objects
                    encountered in the database are returned.
    :param citygml_ids: a list of cityGML IDs. If the list isn&#39;t empty, we keep
                    only the objects of the list

    :return: a string containing the right SQL query that should be executed.
    &#34;&#34;&#34;
    if not buildings:
        # No specific buildings were sought. We thus retrieve all the ones
        # we can find in the database:
        query = &#34;SELECT building.id, cityobject.gmlid &#34; + \
                &#34;FROM citydb.building JOIN citydb.cityobject ON building.id=cityobject.id &#34; + \
                &#34;WHERE building.id=building.building_root_id&#34;
        if len(citygml_ids) &gt; 0:
            citygml_ids_as_string = &#34;(&#39;&#34; + &#34;&#39;, &#39;&#34;.join(citygml_ids) + &#34;&#39;)&#34;
            query += &#34; AND cityobject.gmlid IN &#34; + citygml_ids_as_string
    else:
        building_gmlids = [n.get_gml_id() for n in buildings]
        building_gmlids_as_string = &#34;(&#39;&#34; + &#34;&#39;, &#39;&#34;.join(building_gmlids) + &#34;&#39;)&#34;
        query = &#34;SELECT building.id, cityobject.gmlid &#34; + \
                &#34;FROM citydb.building JOIN citydb.cityobject ON building.id=cityobject.id &#34; + \
                &#34;WHERE cityobject.gmlid IN &#34; + building_gmlids_as_string + &#34; &#34; + \
                &#34;AND building.id=building.building_root_id&#34;

    return query</code></pre>
</details>
</dd>
</dl>
<h3>Inherited members</h3>
<ul class="hlist">
<li><code><b><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects">CityMCityObjects</a></b></code>:
<ul class="hlist">
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.add_material" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.add_material">add_material</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.add_materials" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.add_materials">add_materials</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.change_crs" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.change_crs">change_crs</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.create_batch_table_extension" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.create_batch_table_extension">create_batch_table_extension</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.create_bounding_volume_extension" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.create_bounding_volume_extension">create_bounding_volume_extension</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.delete_features_ref" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.delete_features_ref">delete_features_ref</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_centroid" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.get_centroid">get_centroid</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_color_config" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.get_color_config">get_color_config</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_cursor" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_cursor">get_cursor</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_features" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.get_features">get_features</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_image_from_binary" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_image_from_binary">get_image_from_binary</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_material" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.get_material">get_material</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_material_index" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.get_material_index">get_material_index</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.get_textures" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.get_textures">get_textures</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.is_list_of_feature_list" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.is_list_of_feature_list">is_list_of_feature_list</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.is_material_registered" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.is_material_registered">is_material_registered</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.object_type" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.object_type">object_type</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.retrieve_objects" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.retrieve_objects">retrieve_objects</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.retrieve_textures" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.retrieve_textures">retrieve_textures</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.scale_features" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.scale_features">scale_features</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.set_color_config" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.set_color_config">set_color_config</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.set_cursor" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.set_cursor">set_cursor</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.set_features" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.set_features">set_features</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.set_features_geom" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.set_features_geom">set_features_geom</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.set_materials" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.set_materials">set_materials</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.sql_query_textures" href="citym_cityobject.html#py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.sql_query_textures">sql_query_textures</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_cityobject.CityMCityObjects.translate_features" href="../Common/feature.html#py3dtilers.Common.feature.FeatureList.translate_features">translate_features</a></code></li>
</ul>
</li>
</ul>
</dd>
</dl>
</section>
</article>
<nav id="sidebar">
<h1>Index</h1>
<div class="toc">
<ul></ul>
</div>
<ul id="index">
<li><h3>Super-module</h3>
<ul>
<li><code><a title="py3dtilers.CityTiler" href="index.html">py3dtilers.CityTiler</a></code></li>
</ul>
</li>
<li><h3><a href="#header-classes">Classes</a></h3>
<ul>
<li>
<h4><code><a title="py3dtilers.CityTiler.citym_building.CityMBuilding" href="#py3dtilers.CityTiler.citym_building.CityMBuilding">CityMBuilding</a></code></h4>
</li>
<li>
<h4><code><a title="py3dtilers.CityTiler.citym_building.CityMBuildings" href="#py3dtilers.CityTiler.citym_building.CityMBuildings">CityMBuildings</a></code></h4>
<ul class="">
<li><code><a title="py3dtilers.CityTiler.citym_building.CityMBuildings.is_bth_set" href="#py3dtilers.CityTiler.citym_building.CityMBuildings.is_bth_set">is_bth_set</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_building.CityMBuildings.set_bth" href="#py3dtilers.CityTiler.citym_building.CityMBuildings.set_bth">set_bth</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_centroid" href="#py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_centroid">sql_query_centroid</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_geometries" href="#py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_geometries">sql_query_geometries</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_geometries_with_texture_coordinates" href="#py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_geometries_with_texture_coordinates">sql_query_geometries_with_texture_coordinates</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_objects" href="#py3dtilers.CityTiler.citym_building.CityMBuildings.sql_query_objects">sql_query_objects</a></code></li>
<li><code><a title="py3dtilers.CityTiler.citym_building.CityMBuildings.with_bth" href="#py3dtilers.CityTiler.citym_building.CityMBuildings.with_bth">with_bth</a></code></li>
</ul>
</li>
</ul>
</li>
</ul>
</nav>
</main>
<footer id="footer">
<p>Generated by <a href="https://pdoc3.github.io/pdoc" title="pdoc: Python API documentation generator"><cite>pdoc</cite> 0.10.0</a>.</p>
</footer>
</body>
</html>